'Usage Dim instance As CalcLookupFunction Dim args() As Object Dim value As Object value = instance.Evaluate(args)
Parameters
- args
The args contains 2 - 3 items: lookup_value, lookup_vector, [result_vector].
Lookup_value is A value that LOOKUP searches for in the first vector. Lookup_value can be a number, text, a logical value, or a name or reference that refers to a value.
Lookup_vector A range that contains only one row or one column. The values in lookup_vector can be text, numbers, or logical values.
Result_vector A range that contains only one row or column. It must be the same size as lookup_vector.